﻿CREATE TABLE [dbo].[Role] (
    [Id]           UNIQUEIDENTIFIER NOT NULL,
    [Name]         NVARCHAR (255)   NOT NULL,
    [Active]       BIT              NOT NULL,
    [IsSystemRole] BIT              NOT NULL,
    [SystemName]   NVARCHAR (255)   NULL,
    [Created]      DATETIME         NOT NULL,
    [Modified]     DATETIME         NOT NULL,
    [Description]  NVARCHAR (500)   NULL
);

